## # A tibble: 154 x 5
##    school           `University Hospita… `VA Hospital` `Other Hospital`    total
##    <chr>                           <dbl>         <dbl>            <dbl>    <dbl>
##  1 NYU-Grossman               1243479071      12934726        350379199   1.61e9
##  2 Baylor                              0       3843131       1031370360   1.04e9
##  3 Miami-Miller                611408431      30077231        194630628   8.36e8
##  4 Pittsburgh                          0      31257889        748625546   7.80e8
##  5 U Washington                396957237      98553175        202398902   6.98e8
##  6 Pennsylvania-Pe…            649176108      28072130                0   6.77e8
##  7 Mount Sinai-Ica…                    0             0        667522750   6.68e8
##  8 Indiana                             0      13967498        626197531   6.40e8
##  9 Johns Hopkins                       0             0        540726598   5.41e8
## 10 Emory                       136599359      96568079        304491560   5.38e8
## # … with 144 more rows

## # A tibble: 8 x 4
##   school                pre_clinical clinical total
##   <chr>                        <dbl>    <dbl> <dbl>
## 1 Harvard                        351     9047  9398
## 2 Michigan                       315     2445  2760
## 3 Columbia-Vagelos               268     1896  2164
## 4 Duke                           242     2176  2418
## 5 Johns Hopkins                  232     2719  2951
## 6 Vanderbilt                     193     2514  2707
## 7 Washington U St Louis          158     1951  2109
## 8 Stanford                       153      893  1046

## # A tibble: 8 x 12
##   school        total_funding recorded_percent unrecorded_perc… recorded_dollars
##   <chr>                 <dbl>            <dbl>            <dbl>            <dbl>
## 1 Johns Hopkins     479925893            100                0          479925893
## 2 Washington U…     411987189            100                0          411987189
## 3 Stanford          515682458             96.3              3.7        496661786
## 4 Michigan          418636432             92.5              7.5        387336580
## 5 Duke              549489673             91                9          499805045
## 6 Columbia-Vag…     502354997             82.2             17.8        413158755
## 7 Vanderbilt        388672389             16.9             83.1         65853856
## 8 Harvard          1679349962             13               87          218960886
## # … with 7 more variables: unrecorded_dollars <dbl>, pre_clinical <dbl>,
## #   clinical <dbl>, total_faculty <dbl>, funding_per_all <dbl>,
## #   recorded_per_pre <dbl>, unrecorded_per_clin <dbl>